Deskdrop is an internal communications platform developed by CI&T, focused in companies using Google G Suite. Among other features, this platform allows companies employees to share relevant articles with their peers, and collaborate around them.

libraries used in the data set.

library(ggplot2)
library(plotly)
library(data.table)

Reading the data into r

users_interactions<-fread("users_intractions_format.csv")
shared_articles <- fread("shared_articles_format.csv")

converting the timestamp colum to date time column in r

#strptime("2016-03-29 00:49:39",f)
users_interactions$timestamp<-as.POSIXct(strptime(users_interactions$timestamp, "%Y-%m-%d %H:%M:%S"))
shared_articles$timestamp<-as.POSIXct(strptime(shared_articles$timestamp,"%Y-%m-%d %H:%M:%S"))
users_interactions[rev(order(timestamp)),]
shared_articles[order(timestamp),]

EDA on user intraction

users_interactions
users_interactions$
LS0tDQp0aXRsZTogIkFydGljYWxfc2hhcmluZ19FREEiDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQpEZXNrZHJvcCBpcyBhbiBpbnRlcm5hbCBjb21tdW5pY2F0aW9ucyBwbGF0Zm9ybSBkZXZlbG9wZWQgYnkgQ0kmVCwgZm9jdXNlZCBpbiBjb21wYW5pZXMgdXNpbmcgR29vZ2xlIEcgU3VpdGUuIEFtb25nIG90aGVyIGZlYXR1cmVzLCB0aGlzIHBsYXRmb3JtIGFsbG93cyBjb21wYW5pZXMgZW1wbG95ZWVzIHRvIHNoYXJlIHJlbGV2YW50IGFydGljbGVzIHdpdGggdGhlaXIgcGVlcnMsIGFuZCBjb2xsYWJvcmF0ZSBhcm91bmQgdGhlbS4NCg0KbGlicmFyaWVzIHVzZWQgaW4gdGhlIGRhdGEgc2V0Lg0KYGBge3J9DQpsaWJyYXJ5KGdncGxvdDIpDQpsaWJyYXJ5KHBsb3RseSkNCmxpYnJhcnkoZGF0YS50YWJsZSkNCmBgYA0KDQpSZWFkaW5nIHRoZSBkYXRhIGludG8gcg0KYGBge3J9DQp1c2Vyc19pbnRlcmFjdGlvbnM8LWZyZWFkKCJ1c2Vyc19pbnRyYWN0aW9uc19mb3JtYXQuY3N2IikNCnNoYXJlZF9hcnRpY2xlcyA8LSBmcmVhZCgic2hhcmVkX2FydGljbGVzX2Zvcm1hdC5jc3YiKQ0KYGBgDQoNCmNvbnZlcnRpbmcgdGhlIHRpbWVzdGFtcCBjb2x1bSB0byBkYXRlIHRpbWUgY29sdW1uIGluIHINCmBgYHtyfQ0KI3N0cnB0aW1lKCIyMDE2LTAzLTI5IDAwOjQ5OjM5IixmKQ0KdXNlcnNfaW50ZXJhY3Rpb25zJHRpbWVzdGFtcDwtYXMuUE9TSVhjdChzdHJwdGltZSh1c2Vyc19pbnRlcmFjdGlvbnMkdGltZXN0YW1wLCAiJVktJW0tJWQgJUg6JU06JVMiKSkNCnNoYXJlZF9hcnRpY2xlcyR0aW1lc3RhbXA8LWFzLlBPU0lYY3Qoc3RycHRpbWUoc2hhcmVkX2FydGljbGVzJHRpbWVzdGFtcCwiJVktJW0tJWQgJUg6JU06JVMiKSkNCmBgYA0KDQpgYGB7cn0NCnVzZXJzX2ludGVyYWN0aW9uc1tyZXYob3JkZXIodGltZXN0YW1wKSksXQ0KYGBgDQoNCmBgYHtyfQ0Kc2hhcmVkX2FydGljbGVzW29yZGVyKHRpbWVzdGFtcCksXQ0KYGBgDQoNCkVEQSBvbiB1c2VyIGludHJhY3Rpb24NCmBgYHtyfQ0KdXNlcnNfaW50ZXJhY3Rpb25zDQpgYGANCg0KYGBge3J9DQp1c2Vyc19pbnRlcmFjdGlvbnMkDQpgYGANCg0KDQoNCg0KDQo=